package itsm.isperp.module.repository.slm;

import itsm.isperp.framework.data.mybatis.dao.CUDMapper;
import itsm.isperp.module.entity.db.DbEntityFieldControl;
import itsm.isperp.module.entity.slm.SlmServiceAgreement;

import java.util.Date;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

/// <summary>
/// 描述:slm_service_argument
/// 创建者:zhouhg
/// 创建时间:2013/3/13
/// </summary>
@Repository
public interface SlmServiceAgreementMapper extends
		CUDMapper<SlmServiceAgreement> {

	public List<DbEntityFieldControl> findSlmCalculateFieldControl(
			@Param("id") String id);

	public DbEntityFieldControl findSlmMonitorFieldControl(
			@Param("id") String id);

	// public Object callSpSlmMatch(java.util.Map<String, String> ps);

	public List<Map<String, Object>> callSpSlmMatch(
			@Param("projectId") String projectId,
			@Param("processKey") String processKey,
			@Param("businessKey") String businessKey);

	public void deleteByProjectId(@Param("projectId") String projectId);

	public List<Map<String, Object>> findAllSlm();

	public List<Map<String, Object>> findAllSlmElaspsed();

	public List<Map<String, Object>> findAllSlmElaspsedForOracle(
			@Param("nowTime") Date nowTime, @Param("now") Date now);

	public List<Map<String, Object>> findAllSlmMonitorMap();

}
